# -*- coding:utf-8 -*-

import pandas as pd
from sqlalchemy import create_engine

con=create_engine('mysql+pymysql://root:root@localhost:3306/stack?charset=utf8')
df=pd.read_csv('winner_list_dept_statis-2021-03-15_2021-03-17.csv')

# df.head()

pd.io.sql.to_sql(df, 'winner_list_dept_statis-2021-03-15_2021-03-17', con, if_exists="append")

print('导入成功')